create external table jms_ods.yl_tms_vehicle_line_simple
(
  id               bigint  comment '主键',
  line_name        string  comment '线路名称',
  start_code       string  comment '始发网点编号',
  start_name       string  comment '始发网点名称',
  end_code         string  comment '目的网点编号',
  end_name         string  comment '目的网点名称',
  allocate_vehicle string comment '配载车线',
  line1            string  comment '线路1',
  line2            string comment '线路2',
  line3            string comment '线路3',
  line4            string comment '线路4',
  shifts           bigint  comment '班次',
  operation_model  bigint  comment '运行模式',
  route_type       bigint comment '路由类型',
  vehicle_mode     string comment '最终车型',
  total_mileage    decimal(22,2) comment '总里程',
  mileage1         decimal(22,2)  comment '里程1(km)',
  run_time1        decimal(22,2)  comment '运行时长1(min)',
  departure_time1  string  comment '发车时间1',
  span_days1       bigint  comment '跨天1',
  arrival_time1    string  comment '到达时间1',
  mileage2         decimal(22,2) comment '里程2(km)',
  run_time2        decimal(22,2) comment '运行时长2(min)',
  departure_time2  string comment '发车时间2',
  span_days2       bigint comment '跨天2',
  arrival_time2    string comment '到达时间2',
  mileage3         decimal(22,2) comment '里程3(km)',
  run_time3        decimal(22,2) comment '运行时长3(min)',
  departure_time3  string comment '发车时间3',
  span_days3       bigint comment '跨天3',
  arrival_time3    string comment '到达时间3',
  mileage4         decimal(22,2) comment '里程4(km)',
  run_time4        decimal(22,2) comment '运行时长4(min)',
  departure_time4  string comment '发车时间4',
  span_days4       bigint comment '跨天4',
  arrival_time4    string comment '到达时间4',
  effective_date   timestamp comment '生效时间',
  expiration_date  timestamp comment '失效时间',
  is_enable        bigint comment '是否启用:1启用2禁用3待启用',
  version_name     string comment '版本名称',
  data_sources     string comment '数据来源',
  create_by        bigint comment '创建人id',
  create_by_name   string comment '创建人姓名',
  create_time      timestamp comment '创建时间'
)
comment '干线预测'
partitioned by (dt string comment '时间日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/yl_tms_vehicle_line_simple';